<?php
/**
 * @filesource:					SteleCreateRequestModel.class.php
 * @desc:						立碑模块类
 * 
 * @author:						shenyaqing
 * @copyright:					hou.yining@gmail.com
 * @date:						2011-05-18
 */
class SteleCreateRequestModel extends Model{
	protected $_auto = array ( 
		array('creater_time', 'time', MODEL::MODEL_BOTH, 'function'),
		array('creater_id', 'get_current_operator', MODEL::MODEL_BOTH, 'function'),
		array('creater_name', 'get_current_operator_name', MODEL::MODEL_BOTH, 'function'),
		
	);
	public function getInfo($id){
		$result = $this->query("select r.*,g.name charge_person_name,g.sex,g.age customer_age,g.grade,g.telephone,g.email,g.fax,g.company,g.job work,g.identity_id,g.other,g.education,g.remark customer_remark,g.relations_with_dead,g.province customer_province,g.city customer_city,g.area,g.address customer_address,d.name dead_name,d.gender,d.age dead_age,d.relations_with_charge_person,d.born_time,d.dead_time,d.province dead_province,d.city dead_city,d.address dead_address,d.job dead_job,d.dead_number,d.image_url,d.introduction,d.remark dead_remark from GMS_stele_create_request r,GMS_general_customer g,GMS_dead d where r.charge_person_id=g.id and r.dead_id=d.id and r.id='$id'");
	    return $result;
	}
}
?>